Problem Note 38299: An error occurs when you use the DBDSOPTS= parameter in an IMPORT or an EXPORT procedure
 |  |  |  |
When you use the IMPORT and EXPORT procedures with the DBDSOPTS= parameter, you can receive the following errors:
WARNING: The quoted string currently being processed has become
more than 262 characters long. You may have unbalanced quotation
marks.
more than 262 characters long. You may have unbalanced quotation
marks.
ERROR 79-322: Expecting a ).
ERROR: Unable to parse data set options.
ERROR: Import unsuccessful. See SAS Log for details.
ERROR: Unable to parse data set options.
ERROR: Import unsuccessful. See SAS Log for details.
The problem occurs when DBDSOPTS parameter list is greater than 256 characters, as shown in the following example:
proc import out=mydata2 datafileE="c:\sastest\myfiles.xlsx"
dbms=excel replace;
dbdsopts="dbsastype=(amylase='numeric', alp='numeric', crp='numeric', dht='numeric', got='numeric', gpt='numeric', gamma_gtp='numeric', hdl='numeric',
hb='numeric', hba1c='numeric', ht='numeric', id='numeric'
ldh='numeric', ldh_enzymes='numeric', mch='numeric', mchc='numeric',
mcv='numeric', platelet='numeric', rbc='numeric', time='numeric',
triglyce='numeric', wbc='numeric', alubumin='numeric',
blood_sugar='numeric', creatine='numeric', crpn='numeric',
protein='numeric', testosterone='numeric', total_ch='numeric',
urea_nitrogen='numeric', uric_acid='numeric')";
sheet='sheet1$'n;
getnames=yes;
mixed=yes;
scantext=yes;
usedate=yes;
scantime=yes;
run;
dbms=excel replace;
dbdsopts="dbsastype=(amylase='numeric', alp='numeric', crp='numeric', dht='numeric', got='numeric', gpt='numeric', gamma_gtp='numeric', hdl='numeric',
hb='numeric', hba1c='numeric', ht='numeric', id='numeric'
ldh='numeric', ldh_enzymes='numeric', mch='numeric', mchc='numeric',
mcv='numeric', platelet='numeric', rbc='numeric', time='numeric',
triglyce='numeric', wbc='numeric', alubumin='numeric',
blood_sugar='numeric', creatine='numeric', crpn='numeric',
protein='numeric', testosterone='numeric', total_ch='numeric',
urea_nitrogen='numeric', uric_acid='numeric')";
sheet='sheet1$'n;
getnames=yes;
mixed=yes;
scantext=yes;
usedate=yes;
scantime=yes;
run;
To circumvent the problem, you must shorten the DBDSOPTS= string to 255 characters or fewer.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista | 9.2 TS2M0 | 9.3 TS1M0 | ||
When you use a DBDSOPTS= string that is longer than 256 characters, an error is generated that suggests you have a missing right parenthesis and unbalanced quotation marks.
| Type: | Problem Note |
| Priority: | medium |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> MS Access Data Management ==> Data Sources ==> External Databases ==> MS Excel |
| Date Modified: | 2010-02-09 14:48:19 |
| Date Created: | 2010-01-05 11:58:18 |